load data
 infile 'D:\Userdata\db\allschools3.csv'
 into table schools
 replace 
 fields terminated by "," optionally enclosed by '"'
trailing nullcols
 (scode char "TRIM (:scode)", sname char "TRIM (:sname)", stype char "TRIM (:stype)", scounty char "TRIM (:scounty)", sdistrict char "TRIM (:sdistrict)", 
 percentaa decimal external, 
 percentfem decimal external, percenthis decimal external, 
 enrollment char "TRIM (:enrollment)", saddress char "TRIM (:saddress)", 
scity char "TRIM (:scity)", szip char "TRIM (:szip)", sphone char "TRIM (:sphone)")
